Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 20811 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.0 MiB |
| Average record size in memory | 153.4 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 5 |
IND_ESTADO_INACTIVA has constant value "0" | Constant |
CNT_CUENTAS_DISTINTAS is highly imbalanced (93.9%) | Imbalance |
IND_DEBAJO_UMBRAL_15K is highly imbalanced (78.0%) | Imbalance |
IND_SUP_15K is highly imbalanced (93.9%) | Imbalance |
CNT_CAJEROS_DISTINTOS is highly imbalanced (78.2%) | Imbalance |
PORC_RETIRO is highly skewed (γ1 = 53.22548984) | Skewed |
NUM_AUTORIZACION_TC has unique values | Unique |
Reproduction
| Analysis started | 2023-04-08 22:07:30.583425 |
|---|---|
| Analysis finished | 2023-04-08 22:07:53.511682 |
| Duration | 22.93 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
NUM_AUTORIZACION_TC
Real number (ℝ)
| Distinct | 20811 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 872610.3 |
| Minimum | 804821 |
|---|---|
| Maximum | 938008 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 804821 |
|---|---|
| 5-th percentile | 812684 |
| Q1 | 839491 |
| median | 872871 |
| Q3 | 906917.5 |
| 95-th percentile | 930746 |
| Maximum | 938008 |
| Range | 133187 |
| Interquartile range (IQR) | 67426.5 |
Descriptive statistics
| Standard deviation | 38410.661 |
|---|---|
| Coefficient of variation (CV) | 0.044018116 |
| Kurtosis | -1.2607981 |
| Mean | 872610.3 |
| Median Absolute Deviation (MAD) | 33698 |
| Skewness | -0.02217849 |
| Sum | 1.8159893 × 1010 |
| Variance | 1.4753789 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 886862 | 1 | < 0.1% |
| 847331 | 1 | < 0.1% |
| 912398 | 1 | < 0.1% |
| 906171 | 1 | < 0.1% |
| 872366 | 1 | < 0.1% |
| 829111 | 1 | < 0.1% |
| 816607 | 1 | < 0.1% |
| 933277 | 1 | < 0.1% |
| 808414 | 1 | < 0.1% |
| 932275 | 1 | < 0.1% |
| Other values (20801) | 20801 |
| Value | Count | Frequency (%) |
| 804821 | 1 | |
| 804825 | 1 | |
| 804844 | 1 | |
| 804847 | 1 | |
| 804861 | 1 | |
| 804871 | 1 | |
| 804877 | 1 | |
| 804879 | 1 | |
| 804905 | 1 | |
| 804914 | 1 |
| Value | Count | Frequency (%) |
| 938008 | 1 | |
| 938004 | 1 | |
| 938002 | 1 | |
| 937989 | 1 | |
| 937977 | 1 | |
| 937963 | 1 | |
| 937951 | 1 | |
| 937948 | 1 | |
| 937939 | 1 | |
| 937929 | 1 |
MON_MOVIMIENTO_QUETZALIZADO
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 439.19453 |
| Minimum | 50 |
|---|---|
| Maximum | 4759.22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 100 |
| Q1 | 100 |
| median | 200 |
| Q3 | 500 |
| 95-th percentile | 1500 |
| Maximum | 4759.22 |
| Range | 4709.22 |
| Interquartile range (IQR) | 400 |
Descriptive statistics
| Standard deviation | 518.2961 |
|---|---|
| Coefficient of variation (CV) | 1.180106 |
| Kurtosis | 11.98296 |
| Mean | 439.19453 |
| Median Absolute Deviation (MAD) | 100 |
| Skewness | 2.9123285 |
| Sum | 9140077.4 |
| Variance | 268630.85 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 6647 | |
| 200 | 4066 | |
| 300 | 2660 | |
| 500 | 2468 | 11.9% |
| 1000 | 1959 | 9.4% |
| 2000 | 643 | 3.1% |
| 400 | 549 | 2.6% |
| 600 | 348 | 1.7% |
| 700 | 244 | 1.2% |
| 800 | 219 | 1.1% |
| Other values (89) | 1008 | 4.8% |
| Value | Count | Frequency (%) |
| 50 | 61 | 0.3% |
| 100 | 6647 | |
| 113.12 | 1 | < 0.1% |
| 115.78 | 1 | < 0.1% |
| 150 | 10 | < 0.1% |
| 163.62 | 1 | < 0.1% |
| 200 | 4066 | |
| 250 | 3 | < 0.1% |
| 300 | 2660 | |
| 350 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 4759.22 | 1 | < 0.1% |
| 4757.58 | 1 | < 0.1% |
| 4753.51 | 1 | < 0.1% |
| 4749.12 | 1 | < 0.1% |
| 4747.71 | 2 | < 0.1% |
| 4745.68 | 1 | < 0.1% |
| 4723.37 | 1 | < 0.1% |
| 4721.88 | 1 | < 0.1% |
| 4693.15 | 1 | < 0.1% |
| 3937.77 | 5 |
NUM_CTA_DEB
Real number (ℝ)
| Distinct | 1615 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28612.863 |
| Minimum | 82 |
|---|---|
| Maximum | 47919 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 82 |
|---|---|
| 5-th percentile | 2813.5 |
| Q1 | 19752 |
| median | 30710 |
| Q3 | 39259 |
| 95-th percentile | 46170 |
| Maximum | 47919 |
| Range | 47837 |
| Interquartile range (IQR) | 19507 |
Descriptive statistics
| Standard deviation | 13017.102 |
|---|---|
| Coefficient of variation (CV) | 0.45493882 |
| Kurtosis | -0.70765986 |
| Mean | 28612.863 |
| Median Absolute Deviation (MAD) | 9128 |
| Skewness | -0.51297123 |
| Sum | 5.9546229 × 108 |
| Variance | 1.6944495 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 416 | 58 | 0.3% |
| 407 | 48 | 0.2% |
| 20773 | 40 | 0.2% |
| 25710 | 39 | 0.2% |
| 4702 | 36 | 0.2% |
| 19423 | 35 | 0.2% |
| 22356 | 33 | 0.2% |
| 39904 | 31 | 0.1% |
| 36245 | 31 | 0.1% |
| 11921 | 31 | 0.1% |
| Other values (1605) | 20429 |
| Value | Count | Frequency (%) |
| 82 | 11 | 0.1% |
| 281 | 11 | 0.1% |
| 407 | 48 | |
| 412 | 16 | 0.1% |
| 416 | 58 | |
| 472 | 16 | 0.1% |
| 485 | 6 | < 0.1% |
| 491 | 14 | 0.1% |
| 584 | 11 | 0.1% |
| 590 | 15 | 0.1% |
| Value | Count | Frequency (%) |
| 47919 | 11 | |
| 47847 | 11 | |
| 47819 | 12 | |
| 47788 | 15 | |
| 47777 | 2 | < 0.1% |
| 47775 | 12 | |
| 47750 | 2 | < 0.1% |
| 47748 | 16 | |
| 47746 | 14 | |
| 47717 | 12 |
hora
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.805343 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 34 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 11 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 20 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.1027905 |
|---|---|
| Coefficient of variation (CV) | 0.29718859 |
| Kurtosis | -0.67218048 |
| Mean | 13.805343 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.17473104 |
| Sum | 287303 |
| Variance | 16.83289 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 18 | 1854 | 8.9% |
| 17 | 1822 | 8.8% |
| 12 | 1762 | 8.5% |
| 13 | 1760 | 8.5% |
| 11 | 1588 | 7.6% |
| 16 | 1478 | 7.1% |
| 10 | 1449 | 7.0% |
| 19 | 1448 | 7.0% |
| 15 | 1366 | 6.6% |
| 14 | 1289 | 6.2% |
| Other values (14) | 4995 |
| Value | Count | Frequency (%) |
| 0 | 34 | 0.2% |
| 1 | 29 | 0.1% |
| 2 | 16 | 0.1% |
| 3 | 22 | 0.1% |
| 4 | 27 | 0.1% |
| 5 | 101 | 0.5% |
| 6 | 382 | 1.8% |
| 7 | 638 | |
| 8 | 993 | |
| 9 | 1277 |
| Value | Count | Frequency (%) |
| 23 | 60 | 0.3% |
| 22 | 127 | 0.6% |
| 21 | 390 | 1.9% |
| 20 | 899 | |
| 19 | 1448 | |
| 18 | 1854 | |
| 17 | 1822 | |
| 16 | 1478 | |
| 15 | 1366 | |
| 14 | 1289 |
PAIS_ORIGEN
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.878237 |
| Minimum | 2 |
|---|---|
| Maximum | 49 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 37 |
| Q1 | 37 |
| median | 37 |
| Q3 | 37 |
| 95-th percentile | 37 |
| Maximum | 49 |
| Range | 47 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.6857582 |
|---|---|
| Coefficient of variation (CV) | 0.045711462 |
| Kurtosis | 224.98653 |
| Mean | 36.878237 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -13.312534 |
| Sum | 767473 |
| Variance | 2.8417806 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 37 | 20616 | |
| 22 | 134 | 0.6% |
| 2 | 20 | 0.1% |
| 49 | 15 | 0.1% |
| 40 | 12 | 0.1% |
| 41 | 11 | 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 20 | 0.1% |
| 9 | 3 | < 0.1% |
| 22 | 134 | 0.6% |
| 37 | 20616 | |
| 40 | 12 | 0.1% |
| 41 | 11 | 0.1% |
| 49 | 15 | 0.1% |
| Value | Count | Frequency (%) |
| 49 | 15 | 0.1% |
| 41 | 11 | 0.1% |
| 40 | 12 | 0.1% |
| 37 | 20616 | |
| 22 | 134 | 0.6% |
| 9 | 3 | < 0.1% |
| 2 | 20 | 0.1% |
COD_MONEDA_ORIGEN
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.541204 |
| Minimum | 1 |
|---|---|
| Maximum | 34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 29 |
| median | 29 |
| Q3 | 29 |
| 95-th percentile | 29 |
| Maximum | 34 |
| Range | 33 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.1120776 |
|---|---|
| Coefficient of variation (CV) | 0.10903806 |
| Kurtosis | 47.174467 |
| Mean | 28.541204 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -6.9169319 |
| Sum | 593971 |
| Variance | 9.6850273 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 29 | 20310 | |
| 6 | 344 | 1.7% |
| 19 | 124 | 0.6% |
| 1 | 14 | 0.1% |
| 34 | 10 | < 0.1% |
| 23 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 14 | 0.1% |
| 6 | 344 | 1.7% |
| 19 | 124 | 0.6% |
| 23 | 9 | < 0.1% |
| 29 | 20310 | |
| 34 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 34 | 10 | < 0.1% |
| 29 | 20310 | |
| 23 | 9 | < 0.1% |
| 19 | 124 | 0.6% |
| 6 | 344 | 1.7% |
| 1 | 14 | 0.1% |
COD_PROD_EMISOR
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.1769737 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 4 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 3.3988663 |
|---|---|
| Coefficient of variation (CV) | 0.65653537 |
| Kurtosis | -1.4434622 |
| Mean | 5.1769737 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.55913269 |
| Sum | 107738 |
| Variance | 11.552292 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 2 | 8021 | |
| 10 | 6440 | |
| 4 | 5233 | |
| 6 | 405 | 1.9% |
| 7 | 361 | 1.7% |
| 5 | 188 | 0.9% |
| 3 | 152 | 0.7% |
| 1 | 11 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 11 | 0.1% |
| 2 | 8021 | |
| 3 | 152 | 0.7% |
| 4 | 5233 | |
| 5 | 188 | 0.9% |
| 6 | 405 | 1.9% |
| 7 | 361 | 1.7% |
| 10 | 6440 |
| Value | Count | Frequency (%) |
| 10 | 6440 | |
| 7 | 361 | 1.7% |
| 6 | 405 | 1.9% |
| 5 | 188 | 0.9% |
| 4 | 5233 | |
| 3 | 152 | 0.7% |
| 2 | 8021 | |
| 1 | 11 | 0.1% |
TIP_NEGOCIO
Real number (ℝ)
| Distinct | 2158 |
|---|---|
| Distinct (%) | 10.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2615.0127 |
| Minimum | 1 |
|---|---|
| Maximum | 5699 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 244 |
| Q1 | 1475 |
| median | 2796 |
| Q3 | 3957 |
| 95-th percentile | 4660 |
| Maximum | 5699 |
| Range | 5698 |
| Interquartile range (IQR) | 2482 |
Descriptive statistics
| Standard deviation | 1476.7668 |
|---|---|
| Coefficient of variation (CV) | 0.56472645 |
| Kurtosis | -1.1428807 |
| Mean | 2615.0127 |
| Median Absolute Deviation (MAD) | 1192 |
| Skewness | -0.19338403 |
| Sum | 54421030 |
| Variance | 2180840.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3988 | 828 | 4.0% |
| 123 | 238 | 1.1% |
| 4012 | 228 | 1.1% |
| 4011 | 227 | 1.1% |
| 4007 | 202 | 1.0% |
| 946 | 177 | 0.9% |
| 4225 | 173 | 0.8% |
| 2867 | 91 | 0.4% |
| 3783 | 82 | 0.4% |
| 4009 | 79 | 0.4% |
| Other values (2148) | 18486 |
| Value | Count | Frequency (%) |
| 1 | 4 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 12 | |
| 16 | 23 | |
| 19 | 5 | < 0.1% |
| 21 | 21 | |
| 23 | 9 | < 0.1% |
| 24 | 7 | < 0.1% |
| 25 | 5 | < 0.1% |
| 26 | 20 |
| Value | Count | Frequency (%) |
| 5699 | 21 | |
| 5648 | 2 | < 0.1% |
| 5647 | 15 | |
| 5640 | 19 | |
| 5485 | 15 | |
| 5476 | 1 | < 0.1% |
| 5462 | 5 | < 0.1% |
| 5461 | 7 | < 0.1% |
| 5433 | 3 | < 0.1% |
| 5432 | 3 | < 0.1% |
IND_ESTADO_INACTIVA
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 325.2 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20811 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 20811 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 20811 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20811 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20811 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 20811 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20811 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 20811 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20811 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 20811 |
PORC_RETIRO
Real number (ℝ)
| Distinct | 2203 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 126.05503 |
| Minimum | 0 |
|---|---|
| Maximum | 200000 |
| Zeros | 176 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.02 |
| Q1 | 0.1 |
| median | 0.29 |
| Q3 | 0.98 |
| 95-th percentile | 93.09 |
| Maximum | 200000 |
| Range | 200000 |
| Interquartile range (IQR) | 0.88 |
Descriptive statistics
| Standard deviation | 3274.3999 |
|---|---|
| Coefficient of variation (CV) | 25.975957 |
| Kurtosis | 3044.9434 |
| Mean | 126.05503 |
| Median Absolute Deviation (MAD) | 0.24 |
| Skewness | 53.22549 |
| Sum | 2623331.1 |
| Variance | 10721695 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.02 | 712 | 3.4% |
| 1 | 627 | 3.0% |
| 0.01 | 589 | 2.8% |
| 0.04 | 576 | 2.8% |
| 0.03 | 569 | 2.7% |
| 0.06 | 517 | 2.5% |
| 0.05 | 516 | 2.5% |
| 0.07 | 476 | 2.3% |
| 0.1 | 447 | 2.1% |
| 0.08 | 419 | 2.0% |
| Other values (2193) | 15363 |
| Value | Count | Frequency (%) |
| 0 | 176 | 0.8% |
| 0.01 | 589 | |
| 0.02 | 712 | |
| 0.03 | 569 | |
| 0.04 | 576 | |
| 0.05 | 516 | |
| 0.06 | 517 | |
| 0.07 | 476 | |
| 0.08 | 419 | |
| 0.09 | 418 |
| Value | Count | Frequency (%) |
| 200000 | 4 | |
| 150000 | 1 | < 0.1% |
| 130000 | 1 | < 0.1% |
| 100000 | 1 | < 0.1% |
| 60000 | 1 | < 0.1% |
| 30000 | 3 | |
| 25000 | 1 | < 0.1% |
| 20000 | 1 | < 0.1% |
| 18181.82 | 6 | |
| 16666.67 | 1 | < 0.1% |
CNT_CUENTAS_DISTINTAS
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 325.2 KiB |
| 1 | |
|---|---|
| 2 | 259 |
| 3 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20811 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 20551 | |
| 2 | 259 | 1.2% |
| 3 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 20551 | |
| 2 | 259 | 1.2% |
| 3 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 20551 | |
| 2 | 259 | 1.2% |
| 3 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20811 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 20551 | |
| 2 | 259 | 1.2% |
| 3 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20811 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 20551 | |
| 2 | 259 | 1.2% |
| 3 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20811 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 20551 | |
| 2 | 259 | 1.2% |
| 3 | 1 | < 0.1% |
IND_DEBAJO_UMBRAL_15K
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 325.2 KiB |
| 0 | |
|---|---|
| 1 | 735 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20811 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 20076 | |
| 1 | 735 | 3.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 20076 | |
| 1 | 735 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20076 | |
| 1 | 735 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20811 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 20076 | |
| 1 | 735 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20811 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 20076 | |
| 1 | 735 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20811 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 20076 | |
| 1 | 735 | 3.5% |
IND_SUP_15K
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 325.2 KiB |
| 0 | |
|---|---|
| 1 | 147 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20811 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 20664 | |
| 1 | 147 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 20664 | |
| 1 | 147 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20664 | |
| 1 | 147 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20811 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 20664 | |
| 1 | 147 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20811 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 20664 | |
| 1 | 147 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20811 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 20664 | |
| 1 | 147 | 0.7% |
CNT_RETIRO_CUENTA
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.224785 |
| Minimum | 1 |
|---|---|
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 325.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.54699634 |
|---|---|
| Coefficient of variation (CV) | 0.44660602 |
| Kurtosis | 29.15112 |
| Mean | 1.224785 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.878639 |
| Sum | 25489 |
| Variance | 0.29920499 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 1 | 16990 | |
| 2 | 3208 | 15.4% |
| 3 | 460 | 2.2% |
| 4 | 110 | 0.5% |
| 5 | 24 | 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 3 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 16990 | |
| 2 | 3208 | 15.4% |
| 3 | 460 | 2.2% |
| 4 | 110 | 0.5% |
| 5 | 24 | 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 11 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 8 | 3 | < 0.1% |
| 7 | 4 | < 0.1% |
| 6 | 7 | < 0.1% |
| 5 | 24 | 0.1% |
| 4 | 110 | 0.5% |
| 3 | 460 | 2.2% |
| 2 | 3208 |
CNT_CAJEROS_DISTINTOS
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 325.2 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 145 |
| 4 | 15 |
| 5 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20811 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 18766 | |
| 2 | 1884 | 9.1% |
| 3 | 145 | 0.7% |
| 4 | 15 | 0.1% |
| 5 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 18766 | |
| 2 | 1884 | 9.1% |
| 3 | 145 | 0.7% |
| 4 | 15 | 0.1% |
| 5 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 18766 | |
| 2 | 1884 | 9.1% |
| 3 | 145 | 0.7% |
| 4 | 15 | 0.1% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20811 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 18766 | |
| 2 | 1884 | 9.1% |
| 3 | 145 | 0.7% |
| 4 | 15 | 0.1% |
| 5 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20811 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 18766 | |
| 2 | 1884 | 9.1% |
| 3 | 145 | 0.7% |
| 4 | 15 | 0.1% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20811 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 18766 | |
| 2 | 1884 | 9.1% |
| 3 | 145 | 0.7% |
| 4 | 15 | 0.1% |
| 5 | 1 | < 0.1% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| NUM_AUTORIZACION_TC | MON_MOVIMIENTO_QUETZALIZADO | NUM_CTA_DEB | hora | PAIS_ORIGEN | COD_MONEDA_ORIGEN | COD_PROD_EMISOR | TIP_NEGOCIO | IND_ESTADO_INACTIVA | PORC_RETIRO | CNT_CUENTAS_DISTINTAS | IND_DEBAJO_UMBRAL_15K | IND_SUP_15K | CNT_RETIRO_CUENTA | CNT_CAJEROS_DISTINTOS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COD_CLIENTE | |||||||||||||||
| 38792 | 886862 | 200.0 | 46584 | 8 | 37 | 29 | 10 | 696 | 0 | 0.05 | 1 | 0 | 0 | 1 | 1 |
| 10487 | 890641 | 200.0 | 34338 | 18 | 37 | 29 | 2 | 570 | 0 | 0.19 | 1 | 0 | 0 | 1 | 1 |
| 23357 | 864199 | 300.0 | 14806 | 18 | 37 | 29 | 10 | 639 | 0 | 5.27 | 1 | 0 | 0 | 1 | 1 |
| 8889 | 875335 | 200.0 | 47620 | 8 | 37 | 29 | 2 | 567 | 0 | 0.22 | 1 | 0 | 0 | 2 | 1 |
| 38008 | 845043 | 100.0 | 44739 | 10 | 37 | 29 | 6 | 3806 | 0 | 0.06 | 1 | 0 | 0 | 1 | 1 |
| 26625 | 849303 | 100.0 | 24688 | 12 | 37 | 29 | 4 | 2316 | 0 | 0.18 | 1 | 0 | 0 | 1 | 1 |
| 22765 | 867380 | 600.0 | 24028 | 12 | 37 | 29 | 4 | 3233 | 0 | 0.21 | 1 | 0 | 0 | 1 | 1 |
| 31476 | 860090 | 500.0 | 24714 | 7 | 37 | 29 | 4 | 1999 | 0 | 0.02 | 1 | 0 | 0 | 1 | 1 |
| 4315 | 858690 | 500.0 | 43412 | 14 | 37 | 29 | 2 | 623 | 0 | 0.09 | 1 | 0 | 0 | 2 | 2 |
| 20130 | 894430 | 300.0 | 39480 | 13 | 37 | 29 | 4 | 3713 | 0 | 4.15 | 1 | 0 | 0 | 1 | 1 |
| NUM_AUTORIZACION_TC | MON_MOVIMIENTO_QUETZALIZADO | NUM_CTA_DEB | hora | PAIS_ORIGEN | COD_MONEDA_ORIGEN | COD_PROD_EMISOR | TIP_NEGOCIO | IND_ESTADO_INACTIVA | PORC_RETIRO | CNT_CUENTAS_DISTINTAS | IND_DEBAJO_UMBRAL_15K | IND_SUP_15K | CNT_RETIRO_CUENTA | CNT_CAJEROS_DISTINTOS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COD_CLIENTE | |||||||||||||||
| 39003 | 918266 | 700.0 | 19786 | 13 | 37 | 29 | 10 | 3043 | 0 | 3.46 | 1 | 0 | 0 | 1 | 1 |
| 12922 | 932405 | 700.0 | 35715 | 20 | 37 | 29 | 2 | 2948 | 0 | 35.55 | 1 | 0 | 0 | 1 | 1 |
| 29471 | 930190 | 1000.0 | 36245 | 14 | 37 | 29 | 10 | 1634 | 0 | 1.26 | 1 | 0 | 0 | 1 | 1 |
| 30187 | 850800 | 1000.0 | 41082 | 17 | 37 | 29 | 10 | 194 | 0 | 0.06 | 1 | 0 | 0 | 1 | 1 |
| 18308 | 901102 | 200.0 | 27769 | 19 | 37 | 29 | 2 | 1717 | 0 | 0.71 | 1 | 0 | 0 | 1 | 1 |
| 24124 | 853870 | 200.0 | 31977 | 12 | 37 | 29 | 2 | 3970 | 0 | 1.85 | 1 | 0 | 0 | 1 | 1 |
| 42801 | 832809 | 1000.0 | 19352 | 17 | 37 | 29 | 4 | 942 | 0 | 0.02 | 1 | 0 | 0 | 2 | 1 |
| 37122 | 867433 | 2000.0 | 42949 | 12 | 37 | 29 | 4 | 2128 | 0 | 0.59 | 1 | 1 | 0 | 1 | 1 |
| 18267 | 883573 | 100.0 | 38717 | 13 | 37 | 29 | 4 | 3988 | 0 | 0.09 | 1 | 0 | 0 | 1 | 1 |
| 21659 | 856951 | 200.0 | 39466 | 9 | 37 | 29 | 4 | 2848 | 0 | 0.22 | 1 | 0 | 0 | 1 | 1 |